Aggregate (cost=55815.10..55815.11 rows=1 width=32) CTE t3 -> WindowAgg (cost=55812.49..55815.06 rows=1 width=100) CTE t1 -> GroupAggregate (cost=48320.96..48767.47 rows=19845 width=2300) Group Key: i.code_iris, i.geom, p.location -> Sort (cost=48320.96..48370.57 rows=19845 width=2329) Sort Key: i.code_iris, i.geom, p.location -> Nested Loop (cost=23781.50..35182.48 rows=19845 width=2329) -> Hash Join (cost=23681.50..34807.19 rows=2835 width=2301) Hash Cond: ((i.code_iris)::text = (cl.iris)::text) -> Seq Scan on iris_2016 i (cost=0.00..10418.04 rows=49404 width=2260) -> Hash (cost=23644.76..23644.76 rows=2939 width=51) -> Gather (cost=1000.42..23644.76 rows=2939 width=51) Workers Planned: 1 -> Nested Loop (cost=0.42..22350.86 rows=1729 width=51) -> Append (cost=0.00..18262.60 rows=1772 width=41) -> Parallel Seq Scan on client_visit_history crh (cost=0.00..0.00 rows=1 width=94) Filter: ((duration > 180) AND (timestamp_client_start >= '2018-02-01 00:00:00'::timestamp without time zone) AND (timestamp_client_start < '2018-02-28 00:00:00'::timestamp without time zone) AND (place_id = 178)) -> Parallel Bitmap Heap Scan on _hyper_5_425_chunk crh_1 (cost=1.41..5.77 rows=1 width=41) Recheck Cond: (place_id = 178) Filter: ((duration > 180) AND (timestamp_client_start >= '2018-02-01 00:00:00'::timestamp without time zone) AND (timestamp_client_start < '2018-02-28 00:00:00'::timestamp without time zone)) -> Bitmap Index Scan on _hyper_5_425_chunk_client_visit_pid_idx (cost=0.00..1.41 rows=4 width=0) Index Cond: (place_id = 178) -> Parallel Bitmap Heap Scan on _hyper_5_426_chunk crh_2 (cost=5.03..9.42 rows=1 width=41) Recheck Cond: ((place_id = 178) AND (timestamp_client_start >= '2018-02-01 00:00:00'::timestamp without time zone) AND (timestamp_client_start < '2018-02-28 00:00:00'::timestamp without time zone)) Filter: (duration > 180) -> BitmapAnd (cost=5.03..5.03 rows=4 width=0) -> Bitmap Index Scan on _hyper_5_426_chunk_client_visit_pid_idx (cost=0.00..1.45 rows=8 width=0) Index Cond: (place_id = 178) -> Bitmap Index Scan on _hyper_5_426_chunk_client_visit_timestamp_brin_idx (cost=0.00..3.33 rows=4489 width=0) Index Cond: ((timestamp_client_start >= '2018-02-01 00:00:00'::timestamp without time zone) AND (timestamp_client_start < '2018-02-28 00:00:00'::timestamp without time zone)) -> Parallel Bitmap Heap Scan on _hyper_5_427_chunk crh_3 (cost=1.43..7.98 rows=1 width=41) Recheck Cond: (place_id = 178) Filter: ((duration > 180) AND (timestamp_client_start >= '2018-02-01 00:00:00'::timestamp without time zone) AND (timestamp_client_start < '2018-02-28 00:00:00'::timestamp without time zone)) -> Bitmap Index Scan on _hyper_5_427_chunk_client_visit_pid_idx (cost=0.00..1.43 rows=6 width=0) Index Cond: (place_id = 178) -> Parallel Bitmap Heap Scan on _hyper_5_428_chunk crh_4 (cost=1.42..6.89 rows=1 width=41) Recheck Cond: (place_id = 178) Filter: ((duration > 180) AND (timestamp_client_start >= '2018-02-01 00:00:00'::timestamp without time zone) AND (timestamp_client_start < '2018-02-28 00:00:00'::timestamp without time zone)) -> Bitmap Index Scan on _hyper_5_428_chunk_client_visit_pid_idx (cost=0.00..1.42 rows=5 width=0) Index Cond: (place_id = 178) -> Parallel Bitmap Heap Scan on _hyper_5_429_chunk crh_5 (cost=1.43..7.97 rows=1 width=41) Recheck Cond: (place_id = 178) Filter: ((duration > 180) AND (timestamp_client_start >= '2018-02-01 00:00:00'::timestamp without time zone) AND (timestamp_client_start < '2018-02-28 00:00:00'::timestamp without time zone)) -> Bitmap Index Scan on _hyper_5_429_chunk_client_visit_pid_idx (cost=0.00..1.43 rows=6 width=0) Index Cond: (place_id = 178) -> Parallel Bitmap Heap Scan on _hyper_5_430_chunk crh_6 (cost=1.42..6.88 rows=1 width=41) Recheck Cond: (place_id = 178) Filter: ((duration > 180) AND (timestamp_client_start >= '2018-02-01 00:00:00'::timestamp without time zone) AND (timestamp_client_start < '2018-02-28 00:00:00'::timestamp without time zone)) -> Bitmap Index Scan on _hyper_5_430_chunk_client_visit_pid_idx (cost=0.00..1.42 rows=5 width=0) Index Cond: (place_id = 178) -> Parallel Bitmap Heap Scan on _hyper_5_431_chunk crh_7 (cost=1.42..6.88 rows=1 width=41) Recheck Cond: (place_id = 178) Filter: ((duration > 180) AND (timestamp_client_start >= '2018-02-01 00:00:00'::timestamp without time zone) AND (timestamp_client_start < '2018-02-28 00:00:00'::timestamp without time zone)) -> Bitmap Index Scan on _hyper_5_431_chunk_client_visit_pid_idx (cost=0.00..1.42 rows=5 width=0) Index Cond: (place_id = 178) -> Parallel Bitmap Heap Scan on _hyper_5_432_chunk crh_8 (cost=1.41..5.78 rows=1 width=41) Recheck Cond: (place_id = 178) Filter: ((duration > 180) AND (timestamp_client_start >= '2018-02-01 00:00:00'::timestamp without time zone) AND (timestamp_client_start < '2018-02-28 00:00:00'::timestamp without time zone)) -> Bitmap Index Scan on _hyper_5_432_chunk_client_visit_pid_idx (cost=0.00..1.41 rows=4 width=0) Index Cond: (place_id = 178) -> Parallel Bitmap Heap Scan on _hyper_5_433_chunk crh_9 (cost=1.41..5.78 rows=1 width=41) Recheck Cond: (place_id = 178) Filter: ((duration > 180) AND (timestamp_client_start >= '2018-02-01 00:00:00'::timestamp without time zone) AND (timestamp_client_start < '2018-02-28 00:00:00'::timestamp without time zone)) -> Bitmap Index Scan on _hyper_5_433_chunk_client_visit_pid_idx (cost=0.00..1.41 rows=4 width=0) Index Cond: (place_id = 178) -> Parallel Bitmap Heap Scan on _hyper_5_434_chunk crh_10 (cost=1.42..6.87 rows=1 width=41) Recheck Cond: (place_id = 178) Filter: ((duration > 180) AND (timestamp_client_start >= '2018-02-01 00:00:00'::timestamp without time zone) AND (timestamp_client_start < '2018-02-28 00:00:00'::timestamp without time zone)) -> Bitmap Index Scan on _hyper_5_434_chunk_client_visit_pid_idx (cost=0.00..1.42 rows=5 width=0) Index Cond: (place_id = 178) -> Parallel Bitmap Heap Scan on _hyper_5_435_chunk crh_11 (cost=1.42..6.87 rows=1 width=41) Recheck Cond: (place_id = 178) Filter: ((duration > 180) AND (timestamp_client_start >= '2018-02-01 00:00:00'::timestamp without time zone) AND (timestamp_client_start < '2018-02-28 00:00:00'::timestamp without time zone)) -> Bitmap Index Scan on _hyper_5_435_chunk_client_visit_pid_idx (cost=0.00..1.42 rows=5 width=0) Index Cond: (place_id = 178) -> Parallel Bitmap Heap Scan on _hyper_5_436_chunk crh_12 (cost=1.41..5.78 rows=1 width=41) Recheck Cond: (place_id = 178) Filter: ((duration > 180) AND (timestamp_client_start >= '2018-02-01 00:00:00'::timestamp without time zone) AND (timestamp_client_start < '2018-02-28 00:00:00'::timestamp without time zone)) -> Bitmap Index Scan on _hyper_5_436_chunk_client_visit_pid_idx (cost=0.00..1.41 rows=4 width=0) Index Cond: (place_id = 178) -> Parallel Bitmap Heap Scan on _hyper_5_437_chunk crh_13 (cost=5.06..11.60 rows=1 width=41) Recheck Cond: ((place_id = 178) AND (timestamp_client_start >= '2018-02-01 00:00:00'::timestamp without time zone) AND (timestamp_client_start < '2018-02-28 00:00:00'::timestamp without time zone)) Filter: (duration > 180) -> BitmapAnd (cost=5.06..5.06 rows=6 width=0) -> Bitmap Index Scan on _hyper_5_437_chunk_client_visit_pid_idx (cost=0.00..1.47 rows=12 width=0) Index Cond: (place_id = 178) -> Bitmap Index Scan on _hyper_5_437_chunk_client_visit_timestamp_brin_idx (cost=0.00..3.33 rows=3411 width=0) Index Cond: ((timestamp_client_start >= '2018-02-01 00:00:00'::timestamp without time zone) AND (timestamp_client_start < '2018-02-28 00:00:00'::timestamp without time zone)) -> Parallel Bitmap Heap Scan on _hyper_5_438_chunk crh_14 (cost=5.10..14.93 rows=1 width=41) Recheck Cond: ((place_id = 178) AND (timestamp_client_start >= '2018-02-01 00:00:00'::timestamp without time zone) AND (timestamp_client_start < '2018-02-28 00:00:00'::timestamp without time zone)) Filter: (duration > 180) -> BitmapAnd (cost=5.10..5.10 rows=9 width=0) -> Bitmap Index Scan on _hyper_5_438_chunk_client_visit_pid_idx (cost=0.00..1.52 rows=18 width=0) Index Cond: (place_id = 178) -> Bitmap Index Scan on _hyper_5_438_chunk_client_visit_timestamp_brin_idx (cost=0.00..3.33 rows=5304 width=0) Index Cond: ((timestamp_client_start >= '2018-02-01 00:00:00'::timestamp without time zone) AND (timestamp_client_start < '2018-02-28 00:00:00'::timestamp without time zone)) -> Parallel Bitmap Heap Scan on _hyper_5_439_chunk crh_15 (cost=6.18..80.42 rows=1 width=41) Recheck Cond: ((place_id = 178) AND (timestamp_client_start >= '2018-02-01 00:00:00'::timestamp without time zone) AND (timestamp_client_start < '2018-02-28 00:00:00'::timestamp without time zone)) Filter: (duration > 180) -> BitmapAnd (cost=6.18..6.18 rows=81 width=0) -> Bitmap Index Scan on _hyper_5_439_chunk_client_visit_pid_idx (cost=0.00..2.59 rows=161 width=0) Index Cond: (place_id = 178) -> Bitmap Index Scan on _hyper_5_439_chunk_client_visit_timestamp_brin_idx (cost=0.00..3.33 rows=6067 width=0) Index Cond: ((timestamp_client_start >= '2018-02-01 00:00:00'::timestamp without time zone) AND (timestamp_client_start < '2018-02-28 00:00:00'::timestamp without time zone)) -> Parallel Bitmap Heap Scan on _hyper_5_440_chunk crh_16 (cost=6.29..85.60 rows=1 width=41) Recheck Cond: ((place_id = 178) AND (timestamp_client_start >= '2018-02-01 00:00:00'::timestamp without time zone) AND (timestamp_client_start < '2018-02-28 00:00:00'::timestamp without time zone)) Filter: (duration > 180) -> BitmapAnd (cost=6.29..6.29 rows=88 width=0) -> Bitmap Index Scan on _hyper_5_440_chunk_client_visit_pid_idx (cost=0.00..2.71 rows=176 width=0) Index Cond: (place_id = 178) -> Bitmap Index Scan on _hyper_5_440_chunk_client_visit_timestamp_brin_idx (cost=0.00..3.33 rows=5768 width=0) Index Cond: ((timestamp_client_start >= '2018-02-01 00:00:00'::timestamp without time zone) AND (timestamp_client_start < '2018-02-28 00:00:00'::timestamp without time zone)) -> Parallel Bitmap Heap Scan on _hyper_5_441_chunk crh_17 (cost=6.33..87.75 rows=1 width=41) Recheck Cond: ((place_id = 178) AND (timestamp_client_start >= '2018-02-01 00:00:00'::timestamp without time zone) AND (timestamp_client_start < '2018-02-28 00:00:00'::timestamp without time zone)) Filter: (duration > 180) -> BitmapAnd (cost=6.33..6.33 rows=91 width=0) -> Bitmap Index Scan on _hyper_5_441_chunk_client_visit_pid_idx (cost=0.00..2.74 rows=181 width=0) Index Cond: (place_id = 178) -> Bitmap Index Scan on _hyper_5_441_chunk_client_visit_timestamp_brin_idx (cost=0.00..3.33 rows=5898 width=0) Index Cond: ((timestamp_client_start >= '2018-02-01 00:00:00'::timestamp without time zone) AND (timestamp_client_start < '2018-02-28 00:00:00'::timestamp without time zone)) -> Parallel Bitmap Heap Scan on _hyper_5_442_chunk crh_18 (cost=6.20..80.36 rows=1 width=41) Recheck Cond: ((place_id = 178) AND (timestamp_client_start >= '2018-02-01 00:00:00'::timestamp without time zone) AND (timestamp_client_start < '2018-02-28 00:00:00'::timestamp without time zone)) Filter: (duration > 180) -> BitmapAnd (cost=6.20..6.20 rows=82 width=0) -> Bitmap Index Scan on _hyper_5_442_chunk_client_visit_pid_idx (cost=0.00..2.62 rows=164 width=0) Index Cond: (place_id = 178) -> Bitmap Index Scan on _hyper_5_442_chunk_client_visit_timestamp_brin_idx (cost=0.00..3.33 rows=5779 width=0) Index Cond: ((timestamp_client_start >= '2018-02-01 00:00:00'::timestamp without time zone) AND (timestamp_client_start < '2018-02-28 00:00:00'::timestamp without time zone)) -> Parallel Bitmap Heap Scan on _hyper_5_443_chunk crh_19 (cost=6.57..73.64 rows=1 width=41) Recheck Cond: ((place_id = 178) AND (timestamp_client_start >= '2018-02-01 00:00:00'::timestamp without time zone) AND (timestamp_client_start < '2018-02-28 00:00:00'::timestamp without time zone)) Filter: (duration > 180) -> BitmapAnd (cost=6.57..6.57 rows=71 width=0) -> Bitmap Index Scan on _hyper_5_443_chunk_client_visit_pid_idx (cost=0.00..2.98 rows=213 width=0) Index Cond: (place_id = 178) -> Bitmap Index Scan on _hyper_5_443_chunk_client_visit_timestamp_brin_idx (cost=0.00..3.33 rows=4311 width=0) Index Cond: ((timestamp_client_start >= '2018-02-01 00:00:00'::timestamp without time zone) AND (timestamp_client_start < '2018-02-28 00:00:00'::timestamp without time zone)) -> Parallel Bitmap Heap Scan on _hyper_5_444_chunk crh_20 (cost=6.24..61.82 rows=1 width=41) Recheck Cond: ((place_id = 178) AND (timestamp_client_start >= '2018-02-01 00:00:00'::timestamp without time zone) AND (timestamp_client_start < '2018-02-28 00:00:00'::timestamp without time zone)) Filter: (duration > 180) -> BitmapAnd (cost=6.24..6.24 rows=57 width=0) -> Bitmap Index Scan on _hyper_5_444_chunk_client_visit_pid_idx (cost=0.00..2.66 rows=170 width=0) Index Cond: (place_id = 178) -> Bitmap Index Scan on _hyper_5_444_chunk_client_visit_timestamp_brin_idx (cost=0.00..3.33 rows=4313 width=0) Index Cond: ((timestamp_client_start >= '2018-02-01 00:00:00'::timestamp without time zone) AND (timestamp_client_start < '2018-02-28 00:00:00'::timestamp without time zone)) -> Parallel Bitmap Heap Scan on _hyper_5_445_chunk crh_21 (cost=6.22..60.81 rows=1 width=41) Recheck Cond: ((place_id = 178) AND (timestamp_client_start >= '2018-02-01 00:00:00'::timestamp without time zone) AND (timestamp_client_start < '2018-02-28 00:00:00'::timestamp without time zone)) Filter: (duration > 180) -> BitmapAnd (cost=6.22..6.22 rows=56 width=0) -> Bitmap Index Scan on _hyper_5_445_chunk_client_visit_pid_idx (cost=0.00..2.64 rows=167 width=0) Index Cond: (place_id = 178) -> Bitmap Index Scan on _hyper_5_445_chunk_client_visit_timestamp_brin_idx (cost=0.00..3.33 rows=4529 width=0) Index Cond: ((timestamp_client_start >= '2018-02-01 00:00:00'::timestamp without time zone) AND (timestamp_client_start < '2018-02-28 00:00:00'::timestamp without time zone)) -> Parallel Bitmap Heap Scan on _hyper_5_446_chunk crh_22 (cost=6.37..66.16 rows=1 width=41) Recheck Cond: ((place_id = 178) AND (timestamp_client_start >= '2018-02-01 00:00:00'::timestamp without time zone) AND (timestamp_client_start < '2018-02-28 00:00:00'::timestamp without time zone)) Filter: (duration > 180) -> BitmapAnd (cost=6.37..6.37 rows=62 width=0) -> Bitmap Index Scan on _hyper_5_446_chunk_client_visit_pid_idx (cost=0.00..2.79 rows=187 width=0) Index Cond: (place_id = 178) -> Bitmap Index Scan on _hyper_5_446_chunk_client_visit_timestamp_brin_idx (cost=0.00..3.33 rows=4383 width=0) Index Cond: ((timestamp_client_start >= '2018-02-01 00:00:00'::timestamp without time zone) AND (timestamp_client_start < '2018-02-28 00:00:00'::timestamp without time zone)) -> Parallel Bitmap Heap Scan on _hyper_5_447_chunk crh_23 (cost=6.04..71.74 rows=1 width=41) Recheck Cond: ((place_id = 178) AND (timestamp_client_start >= '2018-02-01 00:00:00'::timestamp without time zone) AND (timestamp_client_start < '2018-02-28 00:00:00'::timestamp without time zone)) Filter: (duration > 180) -> BitmapAnd (cost=6.04..6.04 rows=72 width=0) -> Bitmap Index Scan on _hyper_5_447_chunk_client_visit_pid_idx (cost=0.00..2.46 rows=143 width=0) Index Cond: (place_id = 178) -> Bitmap Index Scan on _hyper_5_447_chunk_client_visit_timestamp_brin_idx (cost=0.00..3.33 rows=5189 width=0) Index Cond: ((timestamp_client_start >= '2018-02-01 00:00:00'::timestamp without time zone) AND (timestamp_client_start < '2018-02-28 00:00:00'::timestamp without time zone)) -> Parallel Bitmap Heap Scan on _hyper_5_448_chunk crh_24 (cost=5.94..65.24 rows=1 width=41) Recheck Cond: ((place_id = 178) AND (timestamp_client_start >= '2018-02-01 00:00:00'::timestamp without time zone) AND (timestamp_client_start < '2018-02-28 00:00:00'::timestamp without time zone)) Filter: (duration > 180) -> BitmapAnd (cost=5.94..5.94 rows=65 width=0) -> Bitmap Index Scan on _hyper_5_448_chunk_client_visit_pid_idx (cost=0.00..2.35 rows=129 width=0) Index Cond: (place_id = 178) -> Bitmap Index Scan on _hyper_5_448_chunk_client_visit_timestamp_brin_idx (cost=0.00..3.33 rows=4567 width=0) Index Cond: ((timestamp_client_start >= '2018-02-01 00:00:00'::timestamp without time zone) AND (timestamp_client_start < '2018-02-28 00:00:00'::timestamp without time zone)) -> Parallel Bitmap Heap Scan on _hyper_5_449_chunk crh_25 (cost=6.09..72.64 rows=1 width=41) Recheck Cond: ((place_id = 178) AND (timestamp_client_start >= '2018-02-01 00:00:00'::timestamp without time zone) AND (timestamp_client_start < '2018-02-28 00:00:00'::timestamp without time zone)) Filter: (duration > 180) -> BitmapAnd (cost=6.09..6.09 rows=75 width=0) -> Bitmap Index Scan on _hyper_5_449_chunk_client_visit_pid_idx (cost=0.00..2.51 rows=150 width=0) Index Cond: (place_id = 178) -> Bitmap Index Scan on _hyper_5_449_chunk_client_visit_timestamp_brin_idx (cost=0.00..3.33 rows=4607 width=0) Index Cond: ((timestamp_client_start >= '2018-02-01 00:00:00'::timestamp without time zone) AND (timestamp_client_start < '2018-02-28 00:00:00'::timestamp without time zone)) -> Parallel Bitmap Heap Scan on _hyper_5_450_chunk crh_26 (cost=6.25..81.21 rows=1 width=41) Recheck Cond: ((place_id = 178) AND (timestamp_client_start >= '2018-02-01 00:00:00'::timestamp without time zone) AND (timestamp_client_start < '2018-02-28 00:00:00'::timestamp without time zone)) Filter: (duration > 180) -> BitmapAnd (cost=6.25..6.25 rows=85 width=0) -> Bitmap Index Scan on _hyper_5_450_chunk_client_visit_pid_idx (cost=0.00..2.67 rows=171 width=0) Index Cond: (place_id = 178) -> Bitmap Index Scan on _hyper_5_450_chunk_client_visit_timestamp_brin_idx (cost=0.00..3.33 rows=5104 width=0) Index Cond: ((timestamp_client_start >= '2018-02-01 00:00:00'::timestamp without time zone) AND (timestamp_client_start < '2018-02-28 00:00:00'::timestamp without time zone)) -> Parallel Bitmap Heap Scan on _hyper_5_451_chunk crh_27 (cost=6.21..79.18 rows=1 width=41) Recheck Cond: ((place_id = 178) AND (timestamp_client_start >= '2018-02-01 00:00:00'::timestamp without time zone) AND (timestamp_client_start < '2018-02-28 00:00:00'::timestamp without time zone)) Filter: (duration > 180) -> BitmapAnd (cost=6.21..6.21 rows=82 width=0) -> Bitmap Index Scan on _hyper_5_451_chunk_client_visit_pid_idx (cost=0.00..2.62 rows=165 width=0) Index Cond: (place_id = 178) -> Bitmap Index Scan on _hyper_5_451_chunk_client_visit_timestamp_brin_idx (cost=0.00..3.33 rows=5290 width=0) Index Cond: ((timestamp_client_start >= '2018-02-01 00:00:00'::timestamp without time zone) AND (timestamp_client_start < '2018-02-28 00:00:00'::timestamp without time zone)) -> Parallel Bitmap Heap Scan on _hyper_5_452_chunk crh_28 (cost=6.77..82.30 rows=1 width=41) Recheck Cond: ((place_id = 178) AND (timestamp_client_start >= '2018-02-01 00:00:00'::timestamp without time zone) AND (timestamp_client_start < '2018-02-28 00:00:00'::timestamp without time zone)) Filter: (duration > 180) -> BitmapAnd (cost=6.77..6.77 rows=80 width=0) -> Bitmap Index Scan on _hyper_5_452_chunk_client_visit_pid_idx (cost=0.00..3.19 rows=240 width=0) Index Cond: (place_id = 178) -> Bitmap Index Scan on _hyper_5_452_chunk_client_visit_timestamp_brin_idx (cost=0.00..3.33 rows=4705 width=0) Index Cond: ((timestamp_client_start >= '2018-02-01 00:00:00'::timestamp without time zone) AND (timestamp_client_start < '2018-02-28 00:00:00'::timestamp without time zone)) -> Parallel Bitmap Heap Scan on _hyper_5_453_chunk crh_29 (cost=9.62..122.70 rows=1 width=41) Recheck Cond: ((timestamp_client_start >= '2018-02-01 00:00:00'::timestamp without time zone) AND (timestamp_client_start < '2018-02-28 00:00:00'::timestamp without time zone) AND (place_id = 178)) Filter: (duration > 180) -> BitmapAnd (cost=9.62..9.62 rows=118 width=0) -> Bitmap Index Scan on _hyper_5_453_chunk_client_visit_timestamp_brin_idx (cost=0.00..3.33 rows=6051 width=0) Index Cond: ((timestamp_client_start >= '2018-02-01 00:00:00'::timestamp without time zone) AND (timestamp_client_start < '2018-02-28 00:00:00'::timestamp without time zone)) -> Bitmap Index Scan on _hyper_5_453_chunk_client_visit_pid_idx (cost=0.00..6.04 rows=473 width=0) Index Cond: (place_id = 178) -> Parallel Bitmap Heap Scan on _hyper_5_454_chunk crh_30 (cost=9.21..110.76 rows=1 width=41) Recheck Cond: ((timestamp_client_start >= '2018-02-01 00:00:00'::timestamp without time zone) AND (timestamp_client_start < '2018-02-28 00:00:00'::timestamp without time zone) AND (place_id = 178)) Filter: (duration > 180) -> BitmapAnd (cost=9.21..9.21 rows=105 width=0) -> Bitmap Index Scan on _hyper_5_454_chunk_client_visit_timestamp_brin_idx (cost=0.00..3.33 rows=5990 width=0) Index Cond: ((timestamp_client_start >= '2018-02-01 00:00:00'::timestamp without time zone) AND (timestamp_client_start < '2018-02-28 00:00:00'::timestamp without time zone)) -> Bitmap Index Scan on _hyper_5_454_chunk_client_visit_pid_idx (cost=0.00..5.63 rows=419 width=0) Index Cond: (place_id = 178) -> Parallel Bitmap Heap Scan on _hyper_5_455_chunk crh_31 (cost=9.62..123.83 rows=1 width=41) Recheck Cond: ((timestamp_client_start >= '2018-02-01 00:00:00'::timestamp without time zone) AND (timestamp_client_start < '2018-02-28 00:00:00'::timestamp without time zone) AND (place_id = 178)) Filter: (duration > 180) -> BitmapAnd (cost=9.62..9.62 rows=119 width=0) -> Bitmap Index Scan on _hyper_5_455_chunk_client_visit_timestamp_brin_idx (cost=0.00..3.33 rows=6256 width=0) Index Cond: ((timestamp_client_start >= '2018-02-01 00:00:00'::timestamp without time zone) AND (timestamp_client_start < '2018-02-28 00:00:00'::timestamp without time zone)) -> Bitmap Index Scan on _hyper_5_455_chunk_client_visit_pid_idx (cost=0.00..6.04 rows=474 width=0) Index Cond: (place_id = 178) -> Parallel Bitmap Heap Scan on _hyper_5_456_chunk crh_32 (cost=9.70..125.96 rows=1 width=41) Recheck Cond: ((timestamp_client_start >= '2018-02-01 00:00:00'::timestamp without time zone) AND (timestamp_client_start < '2018-02-28 00:00:00'::timestamp without time zone) AND (place_id = 178)) Filter: (duration > 180) -> BitmapAnd (cost=9.70..9.70 rows=121 width=0) -> Bitmap Index Scan on _hyper_5_456_chunk_client_visit_timestamp_brin_idx (cost=0.00..3.33 rows=6182 width=0) Index Cond: ((timestamp_client_start >= '2018-02-01 00:00:00'::timestamp without time zone) AND (timestamp_client_start < '2018-02-28 00:00:00'::timestamp without time zone)) -> Bitmap Index Scan on _hyper_5_456_chunk_client_visit_pid_idx (cost=0.00..6.12 rows=484 width=0) Index Cond: (place_id = 178) -> Parallel Bitmap Heap Scan on _hyper_5_457_chunk crh_33 (cost=9.52..100.70 rows=1 width=41) Recheck Cond: ((timestamp_client_start >= '2018-02-01 00:00:00'::timestamp without time zone) AND (timestamp_client_start < '2018-02-28 00:00:00'::timestamp without time zone) AND (place_id = 178)) Filter: (duration > 180) -> BitmapAnd (cost=9.52..9.52 rows=92 width=0) -> Bitmap Index Scan on _hyper_5_457_chunk_client_visit_timestamp_brin_idx (cost=0.00..3.33 rows=5179 width=0) Index Cond: ((timestamp_client_start >= '2018-02-01 00:00:00'::timestamp without time zone) AND (timestamp_client_start < '2018-02-28 00:00:00'::timestamp without time zone)) -> Bitmap Index Scan on _hyper_5_457_chunk_client_visit_pid_idx (cost=0.00..5.94 rows=460 width=0) Index Cond: (place_id = 178) -> Parallel Bitmap Heap Scan on _hyper_5_458_chunk crh_34 (cost=9.84..130.29 rows=1 width=41) Recheck Cond: ((timestamp_client_start >= '2018-02-01 00:00:00'::timestamp without time zone) AND (timestamp_client_start < '2018-02-28 00:00:00'::timestamp without time zone) AND (place_id = 178)) Filter: (duration > 180) -> BitmapAnd (cost=9.84..9.84 rows=126 width=0) -> Bitmap Index Scan on _hyper_5_458_chunk_client_visit_timestamp_brin_idx (cost=0.00..3.33 rows=6214 width=0) Index Cond: ((timestamp_client_start >= '2018-02-01 00:00:00'::timestamp without time zone) AND (timestamp_client_start < '2018-02-28 00:00:00'::timestamp without time zone)) -> Bitmap Index Scan on _hyper_5_458_chunk_client_visit_pid_idx (cost=0.00..6.25 rows=502 width=0) Index Cond: (place_id = 178) -> Parallel Bitmap Heap Scan on _hyper_5_459_chunk crh_35 (cost=11.50..122.64 rows=1 width=41) Recheck Cond: ((timestamp_client_start >= '2018-02-01 00:00:00'::timestamp without time zone) AND (timestamp_client_start < '2018-02-28 00:00:00'::timestamp without time zone) AND (place_id = 178)) Filter: (duration > 180) -> BitmapAnd (cost=11.50..11.50 rows=115 width=0) -> Bitmap Index Scan on _hyper_5_459_chunk_client_visit_timestamp_brin_idx (cost=0.00..3.33 rows=5180 width=0) Index Cond: ((timestamp_client_start >= '2018-02-01 00:00:00'::timestamp without time zone) AND (timestamp_client_start < '2018-02-28 00:00:00'::timestamp without time zone)) -> Bitmap Index Scan on _hyper_5_459_chunk_client_visit_pid_idx (cost=0.00..7.91 rows=577 width=0) Index Cond: (place_id = 178) -> Parallel Bitmap Heap Scan on _hyper_5_460_chunk crh_36 (cost=9.69..106.18 rows=1 width=41) Recheck Cond: ((timestamp_client_start >= '2018-02-01 00:00:00'::timestamp without time zone) AND (timestamp_client_start < '2018-02-28 00:00:00'::timestamp without time zone) AND (place_id = 178)) Filter: (duration > 180) -> BitmapAnd (cost=9.69..9.69 rows=97 width=0) -> Bitmap Index Scan on _hyper_5_460_chunk_client_visit_timestamp_brin_idx (cost=0.00..3.33 rows=5351 width=0) Index Cond: ((timestamp_client_start >= '2018-02-01 00:00:00'::timestamp without time zone) AND (timestamp_client_start < '2018-02-28 00:00:00'::timestamp without time zone)) -> Bitmap Index Scan on _hyper_5_460_chunk_client_visit_pid_idx (cost=0.00..6.11 rows=483 width=0) Index Cond: (place_id = 178) -> Parallel Bitmap Heap Scan on _hyper_5_461_chunk crh_37 (cost=11.71..129.26 rows=1 width=41) Recheck Cond: ((timestamp_client_start >= '2018-02-01 00:00:00'::timestamp without time zone) AND (timestamp_client_start < '2018-02-28 00:00:00'::timestamp without time zone) AND (place_id = 178)) Filter: (duration > 180) -> BitmapAnd (cost=11.71..11.71 rows=121 width=0) -> Bitmap Index Scan on _hyper_5_461_chunk_client_visit_timestamp_brin_idx (cost=0.00..3.33 rows=5495 width=0) Index Cond: ((timestamp_client_start >= '2018-02-01 00:00:00'::timestamp without time zone) AND (timestamp_client_start < '2018-02-28 00:00:00'::timestamp without time zone)) -> Bitmap Index Scan on _hyper_5_461_chunk_client_visit_pid_idx (cost=0.00..8.12 rows=605 width=0) Index Cond: (place_id = 178) -> Parallel Bitmap Heap Scan on _hyper_5_462_chunk crh_38 (cost=11.79..130.40 rows=1 width=41) Recheck Cond: ((timestamp_client_start >= '2018-02-01 00:00:00'::timestamp without time zone) AND (timestamp_client_start < '2018-02-28 00:00:00'::timestamp without time zone) AND (place_id = 178)) Filter: (duration > 180) -> BitmapAnd (cost=11.79..11.79 rows=123 width=0) -> Bitmap Index Scan on _hyper_5_462_chunk_client_visit_timestamp_brin_idx (cost=0.00..3.33 rows=5497 width=0) Index Cond: ((timestamp_client_start >= '2018-02-01 00:00:00'::timestamp without time zone) AND (timestamp_client_start < '2018-02-28 00:00:00'::timestamp without time zone)) -> Bitmap Index Scan on _hyper_5_462_chunk_client_visit_pid_idx (cost=0.00..8.21 rows=616 width=0) Index Cond: (place_id = 178) -> Parallel Bitmap Heap Scan on _hyper_5_463_chunk crh_39 (cost=12.85..157.96 rows=1 width=41) Recheck Cond: ((timestamp_client_start >= '2018-02-01 00:00:00'::timestamp without time zone) AND (timestamp_client_start < '2018-02-28 00:00:00'::timestamp without time zone) AND (place_id = 178)) Filter: (duration > 180) -> BitmapAnd (cost=12.85..12.85 rows=152 width=0) -> Bitmap Index Scan on _hyper_5_463_chunk_client_visit_timestamp_brin_idx (cost=0.00..3.33 rows=6246 width=0) Index Cond: ((timestamp_client_start >= '2018-02-01 00:00:00'::timestamp without time zone) AND (timestamp_client_start < '2018-02-28 00:00:00'::timestamp without time zone)) -> Bitmap Index Scan on _hyper_5_463_chunk_client_visit_pid_idx (cost=0.00..9.27 rows=758 width=0) Index Cond: (place_id = 178) -> Parallel Bitmap Heap Scan on _hyper_5_464_chunk crh_40 (cost=12.07..139.21 rows=1 width=41) Recheck Cond: ((timestamp_client_start >= '2018-02-01 00:00:00'::timestamp without time zone) AND (timestamp_client_start < '2018-02-28 00:00:00'::timestamp without time zone) AND (place_id = 178)) Filter: (duration > 180) -> BitmapAnd (cost=12.07..12.07 rows=131 width=0) -> Bitmap Index Scan on _hyper_5_464_chunk_client_visit_timestamp_brin_idx (cost=0.00..3.33 rows=5853 width=0) Index Cond: ((timestamp_client_start >= '2018-02-01 00:00:00'::timestamp without time zone) AND (timestamp_client_start < '2018-02-28 00:00:00'::timestamp without time zone)) -> Bitmap Index Scan on _hyper_5_464_chunk_client_visit_pid_idx (cost=0.00..8.49 rows=654 width=0) Index Cond: (place_id = 178) -> Parallel Bitmap Heap Scan on _hyper_5_465_chunk crh_41 (cost=9.85..109.44 rows=1 width=41) Recheck Cond: ((timestamp_client_start >= '2018-02-01 00:00:00'::timestamp without time zone) AND (timestamp_client_start < '2018-02-28 00:00:00'::timestamp without time zone) AND (place_id = 178)) Filter: (duration > 180) -> BitmapAnd (cost=9.85..9.85 rows=101 width=0) -> Bitmap Index Scan on _hyper_5_465_chunk_client_visit_timestamp_brin_idx (cost=0.00..3.33 rows=5180 width=0) Index Cond: ((timestamp_client_start >= '2018-02-01 00:00:00'::timestamp without time zone) AND (timestamp_client_start < '2018-02-28 00:00:00'::timestamp without time zone)) -> Bitmap Index Scan on _hyper_5_465_chunk_client_visit_pid_idx (cost=0.00..6.27 rows=504 width=0) Index Cond: (place_id = 178) -> Parallel Bitmap Heap Scan on _hyper_5_466_chunk crh_42 (cost=7.03..92.02 rows=1 width=41) Recheck Cond: ((timestamp_client_start >= '2018-02-01 00:00:00'::timestamp without time zone) AND (timestamp_client_start < '2018-02-28 00:00:00'::timestamp without time zone) AND (place_id = 178)) Filter: (duration > 180) -> BitmapAnd (cost=7.03..7.03 rows=92 width=0) -> Bitmap Index Scan on _hyper_5_466_chunk_client_visit_timestamp_brin_idx (cost=0.00..3.33 rows=4972 width=0) Index Cond: ((timestamp_client_start >= '2018-02-01 00:00:00'::timestamp without time zone) AND (timestamp_client_start < '2018-02-28 00:00:00'::timestamp without time zone)) -> Bitmap Index Scan on _hyper_5_466_chunk_client_visit_pid_idx (cost=0.00..3.45 rows=275 width=0) Index Cond: (place_id = 178) -> Parallel Bitmap Heap Scan on _hyper_5_467_chunk crh_43 (cost=6.70..78.91 rows=1 width=41) Recheck Cond: ((place_id = 178) AND (timestamp_client_start >= '2018-02-01 00:00:00'::timestamp without time zone) AND (timestamp_client_start < '2018-02-28 00:00:00'::timestamp without time zone)) Filter: (duration > 180) -> BitmapAnd (cost=6.70..6.70 rows=77 width=0) -> Bitmap Index Scan on _hyper_5_467_chunk_client_visit_pid_idx (cost=0.00..3.12 rows=231 width=0) Index Cond: (place_id = 178) -> Bitmap Index Scan on _hyper_5_467_chunk_client_visit_timestamp_brin_idx (cost=0.00..3.33 rows=4207 width=0) Index Cond: ((timestamp_client_start >= '2018-02-01 00:00:00'::timestamp without time zone) AND (timestamp_client_start < '2018-02-28 00:00:00'::timestamp without time zone)) -> Parallel Bitmap Heap Scan on _hyper_5_468_chunk crh_44 (cost=9.10..90.84 rows=1 width=41) Recheck Cond: ((timestamp_client_start >= '2018-02-01 00:00:00'::timestamp without time zone) AND (timestamp_client_start < '2018-02-28 00:00:00'::timestamp without time zone) AND (place_id = 178)) Filter: (duration > 180) -> BitmapAnd (cost=9.10..9.10 rows=81 width=0) -> Bitmap Index Scan on _hyper_5_468_chunk_client_visit_timestamp_brin_idx (cost=0.00..3.33 rows=5280 width=0) Index Cond: ((timestamp_client_start >= '2018-02-01 00:00:00'::timestamp without time zone) AND (timestamp_client_start < '2018-02-28 00:00:00'::timestamp without time zone)) -> Bitmap Index Scan on _hyper_5_468_chunk_client_visit_pid_idx (cost=0.00..5.52 rows=404 width=0) Index Cond: (place_id = 178) -> Parallel Bitmap Heap Scan on _hyper_5_469_chunk crh_45 (cost=9.07..78.33 rows=1 width=41) Recheck Cond: ((timestamp_client_start >= '2018-02-01 00:00:00'::timestamp without time zone) AND (timestamp_client_start < '2018-02-28 00:00:00'::timestamp without time zone) AND (place_id = 178)) Filter: (duration > 180) -> BitmapAnd (cost=9.07..9.07 rows=67 width=0) -> Bitmap Index Scan on _hyper_5_469_chunk_client_visit_timestamp_brin_idx (cost=0.00..3.33 rows=5609 width=0) Index Cond: ((timestamp_client_start >= '2018-02-01 00:00:00'::timestamp without time zone) AND (timestamp_client_start < '2018-02-28 00:00:00'::timestamp without time zone)) -> Bitmap Index Scan on _hyper_5_469_chunk_client_visit_pid_idx (cost=0.00..5.48 rows=399 width=0) Index Cond: (place_id = 178) -> Parallel Bitmap Heap Scan on _hyper_5_470_chunk crh_46 (cost=13.00..103.06 rows=1 width=41) Recheck Cond: ((timestamp_client_start >= '2018-02-01 00:00:00'::timestamp without time zone) AND (timestamp_client_start < '2018-02-28 00:00:00'::timestamp without time zone) AND (place_id = 178)) Filter: (duration > 180) -> BitmapAnd (cost=13.00..13.00 rows=86 width=0) -> Bitmap Index Scan on _hyper_5_470_chunk_client_visit_timestamp_brin_idx (cost=0.00..3.33 rows=6056 width=0) Index Cond: ((timestamp_client_start >= '2018-02-01 00:00:00'::timestamp without time zone) AND (timestamp_client_start < '2018-02-28 00:00:00'::timestamp without time zone)) -> Bitmap Index Scan on _hyper_5_470_chunk_client_visit_pid_idx (cost=0.00..9.42 rows=777 width=0) Index Cond: (place_id = 178) -> Parallel Bitmap Heap Scan on _hyper_5_471_chunk crh_47 (cost=17.99..111.62 rows=1 width=41) Recheck Cond: ((timestamp_client_start >= '2018-02-01 00:00:00'::timestamp without time zone) AND (timestamp_client_start < '2018-02-28 00:00:00'::timestamp without time zone) AND (place_id = 178)) Filter: (duration > 180) -> BitmapAnd (cost=17.99..17.99 rows=88 width=0) -> Bitmap Index Scan on _hyper_5_471_chunk_client_visit_timestamp_brin_idx (cost=0.00..3.33 rows=6085 width=0) Index Cond: ((timestamp_client_start >= '2018-02-01 00:00:00'::timestamp without time zone) AND (timestamp_client_start < '2018-02-28 00:00:00'::timestamp without time zone)) -> Bitmap Index Scan on _hyper_5_471_chunk_client_visit_pid_idx (cost=0.00..14.40 rows=1148 width=0) Index Cond: (place_id = 178) -> Parallel Bitmap Heap Scan on _hyper_5_472_chunk crh_48 (cost=19.82..113.64 rows=1 width=41) Recheck Cond: ((timestamp_client_start >= '2018-02-01 00:00:00'::timestamp without time zone) AND (timestamp_client_start < '2018-02-28 00:00:00'::timestamp without time zone) AND (place_id = 178)) Filter: (duration > 180) -> BitmapAnd (cost=19.82..19.82 rows=87 width=0) -> Bitmap Index Scan on _hyper_5_472_chunk_client_visit_timestamp_brin_idx (cost=0.00..3.33 rows=6088 width=0) Index Cond: ((timestamp_client_start >= '2018-02-01 00:00:00'::timestamp without time zone) AND (timestamp_client_start < '2018-02-28 00:00:00'::timestamp without time zone)) -> Bitmap Index Scan on _hyper_5_472_chunk_client_visit_pid_idx (cost=0.00..16.23 rows=1392 width=0) Index Cond: (place_id = 178) -> Parallel Bitmap Heap Scan on _hyper_5_473_chunk crh_49 (cost=20.98..109.46 rows=1 width=41) Recheck Cond: ((timestamp_client_start >= '2018-02-01 00:00:00'::timestamp without time zone) AND (timestamp_client_start < '2018-02-28 00:00:00'::timestamp without time zone) AND (place_id = 178)) Filter: (duration > 180) -> BitmapAnd (cost=20.98..20.98 rows=82 width=0) -> Bitmap Index Scan on _hyper_5_473_chunk_client_visit_timestamp_brin_idx (cost=0.00..3.33 rows=6128 width=0) Index Cond: ((timestamp_client_start >= '2018-02-01 00:00:00'::timestamp without time zone) AND (timestamp_client_start < '2018-02-28 00:00:00'::timestamp without time zone)) -> Bitmap Index Scan on _hyper_5_473_chunk_client_visit_pid_idx (cost=0.00..17.40 rows=1401 width=0) Index Cond: (place_id = 178) -> Parallel Bitmap Heap Scan on _hyper_5_474_chunk crh_50 (cost=19.63..105.95 rows=1 width=41) Recheck Cond: ((timestamp_client_start >= '2018-02-01 00:00:00'::timestamp without time zone) AND (timestamp_client_start < '2018-02-28 00:00:00'::timestamp without time zone) AND (place_id = 178)) Filter: (duration > 180) -> BitmapAnd (cost=19.63..19.63 rows=80 width=0) -> Bitmap Index Scan on _hyper_5_474_chunk_client_visit_timestamp_brin_idx (cost=0.00..3.33 rows=6255 width=0) Index Cond: ((timestamp_client_start >= '2018-02-01 00:00:00'::timestamp without time zone) AND (timestamp_client_start < '2018-02-28 00:00:00'::timestamp without time zone)) -> Bitmap Index Scan on _hyper_5_474_chunk_client_visit_pid_idx (cost=0.00..16.05 rows=1367 width=0) Index Cond: (place_id = 178) -> Parallel Bitmap Heap Scan on _hyper_5_475_chunk crh_51 (cost=21.22..107.59 rows=1 width=41) Recheck Cond: ((timestamp_client_start >= '2018-02-01 00:00:00'::timestamp without time zone) AND (timestamp_client_start < '2018-02-28 00:00:00'::timestamp without time zone) AND (place_id = 178)) Filter: (duration > 180) -> BitmapAnd (cost=21.22..21.22 rows=80 width=0) -> Bitmap Index Scan on _hyper_5_475_chunk_client_visit_timestamp_brin_idx (cost=0.00..3.33 rows=6238 width=0) Index Cond: ((timestamp_client_start >= '2018-02-01 00:00:00'::timestamp without time zone) AND (timestamp_client_start < '2018-02-28 00:00:00'::timestamp without time zone)) -> Bitmap Index Scan on _hyper_5_475_chunk_client_visit_pid_idx (cost=0.00..17.64 rows=1433 width=0) Index Cond: (place_id = 178) -> Parallel Bitmap Heap Scan on _hyper_5_476_chunk crh_52 (cost=25.73..113.35 rows=1 width=41) Recheck Cond: ((timestamp_client_start >= '2018-02-01 00:00:00'::timestamp without time zone) AND (timestamp_client_start < '2018-02-28 00:00:00'::timestamp without time zone) AND (place_id = 178)) Filter: (duration > 180) -> BitmapAnd (cost=25.73..25.73 rows=81 width=0) -> Bitmap Index Scan on _hyper_5_476_chunk_client_visit_timestamp_brin_idx (cost=0.00..3.33 rows=6195 width=0) Index Cond: ((timestamp_client_start >= '2018-02-01 00:00:00'::timestamp without time zone) AND (timestamp_client_start < '2018-02-28 00:00:00'::timestamp without time zone)) -> Bitmap Index Scan on _hyper_5_476_chunk_client_visit_pid_idx (cost=0.00..22.15 rows=1870 width=0) Index Cond: (place_id = 178) -> Parallel Bitmap Heap Scan on _hyper_5_477_chunk crh_53 (cost=27.76..112.18 rows=1 width=41) Recheck Cond: ((timestamp_client_start >= '2018-02-01 00:00:00'::timestamp without time zone) AND (timestamp_client_start < '2018-02-28 00:00:00'::timestamp without time zone) AND (place_id = 178)) Filter: (duration > 180) -> BitmapAnd (cost=27.76..27.76 rows=77 width=0) -> Bitmap Index Scan on _hyper_5_477_chunk_client_visit_timestamp_brin_idx (cost=0.00..3.33 rows=6175 width=0) Index Cond: ((timestamp_client_start >= '2018-02-01 00:00:00'::timestamp without time zone) AND (timestamp_client_start < '2018-02-28 00:00:00'::timestamp without time zone)) -> Bitmap Index Scan on _hyper_5_477_chunk_client_visit_pid_idx (cost=0.00..24.18 rows=1994 width=0) Index Cond: (place_id = 178) -> Parallel Bitmap Heap Scan on _hyper_5_478_chunk crh_54 (cost=25.68..104.66 rows=1 width=41) Recheck Cond: ((timestamp_client_start >= '2018-02-01 00:00:00'::timestamp without time zone) AND (timestamp_client_start < '2018-02-28 00:00:00'::timestamp without time zone) AND (place_id = 178)) Filter: (duration > 180) -> BitmapAnd (cost=25.68..25.68 rows=72 width=0) -> Bitmap Index Scan on _hyper_5_478_chunk_client_visit_timestamp_brin_idx (cost=0.00..3.33 rows=6229 width=0) Index Cond: ((timestamp_client_start >= '2018-02-01 00:00:00'::timestamp without time zone) AND (timestamp_client_start < '2018-02-28 00:00:00'::timestamp without time zone)) -> Bitmap Index Scan on _hyper_5_478_chunk_client_visit_pid_idx (cost=0.00..22.10 rows=1864 width=0) Index Cond: (place_id = 178) -> Parallel Bitmap Heap Scan on _hyper_5_479_chunk crh_55 (cost=28.94..110.16 rows=1 width=41) Recheck Cond: ((timestamp_client_start >= '2018-02-01 00:00:00'::timestamp without time zone) AND (timestamp_client_start < '2018-02-28 00:00:00'::timestamp without time zone) AND (place_id = 178)) Filter: (duration > 180) -> BitmapAnd (cost=28.94..28.94 rows=74 width=0) -> Bitmap Index Scan on _hyper_5_479_chunk_client_visit_timestamp_brin_idx (cost=0.00..3.33 rows=6298 width=0) Index Cond: ((timestamp_client_start >= '2018-02-01 00:00:00'::timestamp without time zone) AND (timestamp_client_start < '2018-02-28 00:00:00'::timestamp without time zone)) -> Bitmap Index Scan on _hyper_5_479_chunk_client_visit_pid_idx (cost=0.00..25.35 rows=2151 width=0) Index Cond: (place_id = 178) -> Parallel Bitmap Heap Scan on _hyper_5_480_chunk crh_56 (cost=26.16..112.72 rows=1 width=41) Recheck Cond: ((timestamp_client_start >= '2018-02-01 00:00:00'::timestamp without time zone) AND (timestamp_client_start < '2018-02-28 00:00:00'::timestamp without time zone) AND (place_id = 178)) Filter: (duration > 180) -> BitmapAnd (cost=26.16..26.16 rows=80 width=0) -> Bitmap Index Scan on _hyper_5_480_chunk_client_visit_timestamp_brin_idx (cost=0.00..3.33 rows=6388 width=0) Index Cond: ((timestamp_client_start >= '2018-02-01 00:00:00'::timestamp without time zone) AND (timestamp_client_start < '2018-02-28 00:00:00'::timestamp without time zone)) -> Bitmap Index Scan on _hyper_5_480_chunk_client_visit_pid_idx (cost=0.00..22.57 rows=1927 width=0) Index Cond: (place_id = 178) -> Parallel Bitmap Heap Scan on _hyper_5_481_chunk crh_57 (cost=25.17..107.38 rows=1 width=41) Recheck Cond: ((timestamp_client_start >= '2018-02-01 00:00:00'::timestamp without time zone) AND (timestamp_client_start < '2018-02-28 00:00:00'::timestamp without time zone) AND (place_id = 178)) Filter: (duration > 180) -> BitmapAnd (cost=25.17..25.17 rows=75 width=0) -> Bitmap Index Scan on _hyper_5_481_chunk_client_visit_timestamp_brin_idx (cost=0.00..3.33 rows=6524 width=0) Index Cond: ((timestamp_client_start >= '2018-02-01 00:00:00'::timestamp without time zone) AND (timestamp_client_start < '2018-02-28 00:00:00'::timestamp without time zone)) -> Bitmap Index Scan on _hyper_5_481_chunk_client_visit_pid_idx (cost=0.00..21.59 rows=1796 width=0) Index Cond: (place_id = 178) -> Parallel Bitmap Heap Scan on _hyper_5_482_chunk crh_58 (cost=24.79..98.31 rows=1 width=41) Recheck Cond: ((timestamp_client_start >= '2018-02-01 00:00:00'::timestamp without time zone) AND (timestamp_client_start < '2018-02-28 00:00:00'::timestamp without time zone) AND (place_id = 178)) Filter: (duration > 180) -> BitmapAnd (cost=24.79..24.79 rows=67 width=0) -> Bitmap Index Scan on _hyper_5_482_chunk_client_visit_timestamp_brin_idx (cost=0.00..3.33 rows=6519 width=0) Index Cond: ((timestamp_client_start >= '2018-02-01 00:00:00'::timestamp without time zone) AND (timestamp_client_start < '2018-02-28 00:00:00'::timestamp without time zone)) -> Bitmap Index Scan on _hyper_5_482_chunk_client_visit_pid_idx (cost=0.00..21.21 rows=1745 width=0) Index Cond: (place_id = 178) -> Parallel Bitmap Heap Scan on _hyper_5_483_chunk crh_59 (cost=22.65..90.73 rows=1 width=41) Recheck Cond: ((timestamp_client_start >= '2018-02-01 00:00:00'::timestamp without time zone) AND (timestamp_client_start < '2018-02-28 00:00:00'::timestamp without time zone) AND (place_id = 178)) Filter: (duration > 180) -> BitmapAnd (cost=22.65..22.65 rows=62 width=0) -> Bitmap Index Scan on _hyper_5_483_chunk_client_visit_timestamp_brin_idx (cost=0.00..3.33 rows=6724 width=0) Index Cond: ((timestamp_client_start >= '2018-02-01 00:00:00'::timestamp without time zone) AND (timestamp_client_start < '2018-02-28 00:00:00'::timestamp without time zone)) -> Bitmap Index Scan on _hyper_5_483_chunk_client_visit_pid_idx (cost=0.00..19.07 rows=1606 width=0) Index Cond: (place_id = 178) -> Parallel Bitmap Heap Scan on _hyper_5_484_chunk crh_60 (cost=28.04..104.89 rows=1 width=41) Recheck Cond: ((timestamp_client_start >= '2018-02-01 00:00:00'::timestamp without time zone) AND (timestamp_client_start < '2018-02-28 00:00:00'::timestamp without time zone) AND (place_id = 178)) Filter: (duration > 180) -> BitmapAnd (cost=28.04..28.04 rows=70 width=0) -> Bitmap Index Scan on _hyper_5_484_chunk_client_visit_timestamp_brin_idx (cost=0.00..3.33 rows=6585 width=0) Index Cond: ((timestamp_client_start >= '2018-02-01 00:00:00'::timestamp without time zone) AND (timestamp_client_start < '2018-02-28 00:00:00'::timestamp without time zone)) -> Bitmap Index Scan on _hyper_5_484_chunk_client_visit_pid_idx (cost=0.00..24.45 rows=2031 width=0) Index Cond: (place_id = 178) -> Parallel Bitmap Heap Scan on _hyper_5_485_chunk crh_61 (cost=28.15..100.66 rows=1 width=41) Recheck Cond: ((timestamp_client_start >= '2018-02-01 00:00:00'::timestamp without time zone) AND (timestamp_client_start < '2018-02-28 00:00:00'::timestamp without time zone) AND (place_id = 178)) Filter: (duration > 180) -> BitmapAnd (cost=28.15..28.15 rows=66 width=0) -> Bitmap Index Scan on _hyper_5_485_chunk_client_visit_timestamp_brin_idx (cost=0.00..3.33 rows=6604 width=0) Index Cond: ((timestamp_client_start >= '2018-02-01 00:00:00'::timestamp without time zone) AND (timestamp_client_start < '2018-02-28 00:00:00'::timestamp without time zone)) -> Bitmap Index Scan on _hyper_5_485_chunk_client_visit_pid_idx (cost=0.00..24.57 rows=2046 width=0) Index Cond: (place_id = 178) -> Parallel Bitmap Heap Scan on _hyper_5_538_chunk crh_62 (cost=29.07..99.44 rows=1 width=41) Recheck Cond: ((timestamp_client_start >= '2018-02-01 00:00:00'::timestamp without time zone) AND (timestamp_client_start < '2018-02-28 00:00:00'::timestamp without time zone) AND (place_id = 178)) Filter: (duration > 180) -> BitmapAnd (cost=29.07..29.07 rows=64 width=0) -> Bitmap Index Scan on _hyper_5_538_chunk_client_visit_timestamp_brin_idx (cost=0.00..3.33 rows=6569 width=0) Index Cond: ((timestamp_client_start >= '2018-02-01 00:00:00'::timestamp without time zone) AND (timestamp_client_start < '2018-02-28 00:00:00'::timestamp without time zone)) -> Bitmap Index Scan on _hyper_5_538_chunk_client_visit_pid_idx (cost=0.00..25.49 rows=2169 width=0) Index Cond: (place_id = 178) -> Parallel Bitmap Heap Scan on _hyper_5_539_chunk crh_63 (cost=34.59..108.30 rows=1 width=41) Recheck Cond: ((timestamp_client_start >= '2018-02-01 00:00:00'::timestamp without time zone) AND (timestamp_client_start < '2018-02-28 00:00:00'::timestamp without time zone) AND (place_id = 178)) Filter: (duration > 180) -> BitmapAnd (cost=34.59..34.59 rows=67 width=0) -> Bitmap Index Scan on _hyper_5_539_chunk_client_visit_timestamp_brin_idx (cost=0.00..3.33 rows=6686 width=0) Index Cond: ((timestamp_client_start >= '2018-02-01 00:00:00'::timestamp without time zone) AND (timestamp_client_start < '2018-02-28 00:00:00'::timestamp without time zone)) -> Bitmap Index Scan on _hyper_5_539_chunk_client_visit_pid_idx (cost=0.00..31.00 rows=2611 width=0) Index Cond: (place_id = 178) -> Parallel Bitmap Heap Scan on _hyper_5_540_chunk crh_64 (cost=32.42..106.11 rows=1 width=41) Recheck Cond: ((timestamp_client_start >= '2018-02-01 00:00:00'::timestamp without time zone) AND (timestamp_client_start < '2018-02-28 00:00:00'::timestamp without time zone) AND (place_id = 178)) Filter: (duration > 180) -> BitmapAnd (cost=32.42..32.42 rows=67 width=0) -> Bitmap Index Scan on _hyper_5_540_chunk_client_visit_timestamp_brin_idx (cost=0.00..3.33 rows=6632 width=0) Index Cond: ((timestamp_client_start >= '2018-02-01 00:00:00'::timestamp without time zone) AND (timestamp_client_start < '2018-02-28 00:00:00'::timestamp without time zone)) -> Bitmap Index Scan on _hyper_5_540_chunk_client_visit_pid_idx (cost=0.00..28.84 rows=2469 width=0) Index Cond: (place_id = 178) -> Parallel Bitmap Heap Scan on _hyper_5_541_chunk crh_65 (cost=27.74..98.08 rows=1 width=41) Recheck Cond: ((timestamp_client_start >= '2018-02-01 00:00:00'::timestamp without time zone) AND (timestamp_client_start < '2018-02-28 00:00:00'::timestamp without time zone) AND (place_id = 178)) Filter: (duration > 180) -> BitmapAnd (cost=27.74..27.74 rows=64 width=0) -> Bitmap Index Scan on _hyper_5_541_chunk_client_visit_timestamp_brin_idx (cost=0.00..3.33 rows=6657 width=0) Index Cond: ((timestamp_client_start >= '2018-02-01 00:00:00'::timestamp without time zone) AND (timestamp_client_start < '2018-02-28 00:00:00'::timestamp without time zone)) -> Bitmap Index Scan on _hyper_5_541_chunk_client_visit_pid_idx (cost=0.00..24.16 rows=1992 width=0) Index Cond: (place_id = 178) -> Parallel Bitmap Heap Scan on _hyper_5_542_chunk crh_66 (cost=24.48..89.32 rows=1 width=41) Recheck Cond: ((timestamp_client_start >= '2018-02-01 00:00:00'::timestamp without time zone) AND (timestamp_client_start < '2018-02-28 00:00:00'::timestamp without time zone) AND (place_id = 178)) Filter: (duration > 180) -> BitmapAnd (cost=24.48..24.48 rows=59 width=0) -> Bitmap Index Scan on _hyper_5_542_chunk_client_visit_timestamp_brin_idx (cost=0.00..3.33 rows=6623 width=0) Index Cond: ((timestamp_client_start >= '2018-02-01 00:00:00'::timestamp without time zone) AND (timestamp_client_start < '2018-02-28 00:00:00'::timestamp without time zone)) -> Bitmap Index Scan on _hyper_5_542_chunk_client_visit_pid_idx (cost=0.00..20.89 rows=1703 width=0) Index Cond: (place_id = 178) -> Parallel Bitmap Heap Scan on _hyper_5_543_chunk crh_67 (cost=24.91..87.59 rows=1 width=41) Recheck Cond: ((timestamp_client_start >= '2018-02-01 00:00:00'::timestamp without time zone) AND (timestamp_client_start < '2018-02-28 00:00:00'::timestamp without time zone) AND (place_id = 178)) Filter: (duration > 180) -> BitmapAnd (cost=24.91..24.91 rows=57 width=0) -> Bitmap Index Scan on _hyper_5_543_chunk_client_visit_timestamp_brin_idx (cost=0.00..3.33 rows=6621 width=0) Index Cond: ((timestamp_client_start >= '2018-02-01 00:00:00'::timestamp without time zone) AND (timestamp_client_start < '2018-02-28 00:00:00'::timestamp without time zone)) -> Bitmap Index Scan on _hyper_5_543_chunk_client_visit_pid_idx (cost=0.00..21.33 rows=1761 width=0) Index Cond: (place_id = 178) -> Parallel Bitmap Heap Scan on _hyper_5_544_chunk crh_68 (cost=21.79..93.08 rows=1 width=41) Recheck Cond: ((timestamp_client_start >= '2018-02-01 00:00:00'::timestamp without time zone) AND (timestamp_client_start < '2018-02-28 00:00:00'::timestamp without time zone) AND (place_id = 178)) Filter: (duration > 180) -> BitmapAnd (cost=21.79..21.79 rows=65 width=0) -> Bitmap Index Scan on _hyper_5_544_chunk_client_visit_timestamp_brin_idx (cost=0.00..3.33 rows=6546 width=0) Index Cond: ((timestamp_client_start >= '2018-02-01 00:00:00'::timestamp without time zone) AND (timestamp_client_start < '2018-02-28 00:00:00'::timestamp without time zone)) -> Bitmap Index Scan on _hyper_5_544_chunk_client_visit_pid_idx (cost=0.00..18.21 rows=1492 width=0) Index Cond: (place_id = 178) -> Parallel Bitmap Heap Scan on _hyper_5_545_chunk crh_69 (cost=18.44..100.38 rows=1 width=41) Recheck Cond: ((timestamp_client_start >= '2018-02-01 00:00:00'::timestamp without time zone) AND (timestamp_client_start < '2018-02-28 00:00:00'::timestamp without time zone) AND (place_id = 178)) Filter: (duration > 180) -> BitmapAnd (cost=18.44..18.44 rows=76 width=0) -> Bitmap Index Scan on _hyper_5_545_chunk_client_visit_timestamp_brin_idx (cost=0.00..3.33 rows=6182 width=0) Index Cond: ((timestamp_client_start >= '2018-02-01 00:00:00'::timestamp without time zone) AND (timestamp_client_start < '2018-02-28 00:00:00'::timestamp without time zone)) -> Bitmap Index Scan on _hyper_5_545_chunk_client_visit_pid_idx (cost=0.00..14.86 rows=1209 width=0) Index Cond: (place_id = 178) -> Parallel Bitmap Heap Scan on _hyper_5_546_chunk crh_70 (cost=15.34..1098.85 rows=396 width=41) Recheck Cond: (place_id = 178) Filter: ((duration > 180) AND (timestamp_client_start >= '2018-02-01 00:00:00'::timestamp without time zone) AND (timestamp_client_start < '2018-02-28 00:00:00'::timestamp without time zone)) -> Bitmap Index Scan on _hyper_5_546_chunk_client_visit_pid_idx (cost=0.00..15.17 rows=1234 width=0) Index Cond: (place_id = 178) -> Parallel Bitmap Heap Scan on _hyper_5_547_chunk crh_71 (cost=15.66..1148.05 rows=408 width=41) Recheck Cond: (place_id = 178) Filter: ((duration > 180) AND (timestamp_client_start >= '2018-02-01 00:00:00'::timestamp without time zone) AND (timestamp_client_start < '2018-02-28 00:00:00'::timestamp without time zone)) -> Bitmap Index Scan on _hyper_5_547_chunk_client_visit_pid_idx (cost=0.00..15.49 rows=1276 width=0) Index Cond: (place_id = 178) -> Parallel Bitmap Heap Scan on _hyper_5_548_chunk crh_72 (cost=18.39..1284.53 rows=473 width=41) Recheck Cond: (place_id = 178) Filter: ((duration > 180) AND (timestamp_client_start >= '2018-02-01 00:00:00'::timestamp without time zone) AND (timestamp_client_start < '2018-02-28 00:00:00'::timestamp without time zone)) -> Bitmap Index Scan on _hyper_5_548_chunk_client_visit_pid_idx (cost=0.00..18.19 rows=1489 width=0) Index Cond: (place_id = 178) -> Parallel Bitmap Heap Scan on _hyper_5_549_chunk crh_73 (cost=21.12..1129.02 rows=390 width=41) Recheck Cond: ((timestamp_client_start >= '2018-02-01 00:00:00'::timestamp without time zone) AND (timestamp_client_start < '2018-02-28 00:00:00'::timestamp without time zone) AND (place_id = 178)) Filter: (duration > 180) -> BitmapAnd (cost=21.12..21.12 rows=1249 width=0) -> Bitmap Index Scan on _hyper_5_549_chunk_client_visit_timestamp_brin_idx (cost=0.00..4.04 rows=143301 width=0) Index Cond: ((timestamp_client_start >= '2018-02-01 00:00:00'::timestamp without time zone) AND (timestamp_client_start < '2018-02-28 00:00:00'::timestamp without time zone)) -> Bitmap Index Scan on _hyper_5_549_chunk_client_visit_pid_idx (cost=0.00..16.50 rows=1411 width=0) Index Cond: (place_id = 178) -> Parallel Bitmap Heap Scan on _hyper_5_550_chunk crh_74 (cost=19.24..76.38 rows=1 width=41) Recheck Cond: ((timestamp_client_start >= '2018-02-01 00:00:00'::timestamp without time zone) AND (timestamp_client_start < '2018-02-28 00:00:00'::timestamp without time zone) AND (place_id = 178)) Filter: (duration > 180) -> BitmapAnd (cost=19.24..19.24 rows=52 width=0) -> Bitmap Index Scan on _hyper_5_550_chunk_client_visit_timestamp_brin_idx (cost=0.00..3.33 rows=6271 width=0) Index Cond: ((timestamp_client_start >= '2018-02-01 00:00:00'::timestamp without time zone) AND (timestamp_client_start < '2018-02-28 00:00:00'::timestamp without time zone)) -> Bitmap Index Scan on _hyper_5_550_chunk_client_visit_pid_idx (cost=0.00..15.65 rows=1298 width=0) Index Cond: (place_id = 178) -> Parallel Bitmap Heap Scan on _hyper_5_551_chunk crh_75 (cost=20.87..76.94 rows=1 width=41) Recheck Cond: ((timestamp_client_start >= '2018-02-01 00:00:00'::timestamp without time zone) AND (timestamp_client_start < '2018-02-28 00:00:00'::timestamp without time zone) AND (place_id = 178)) Filter: (duration > 180) -> BitmapAnd (cost=20.87..20.87 rows=51 width=0) -> Bitmap Index Scan on _hyper_5_551_chunk_client_visit_timestamp_brin_idx (cost=0.00..3.33 rows=6177 width=0) Index Cond: ((timestamp_client_start >= '2018-02-01 00:00:00'::timestamp without time zone) AND (timestamp_client_start < '2018-02-28 00:00:00'::timestamp without time zone)) -> Bitmap Index Scan on _hyper_5_551_chunk_client_visit_pid_idx (cost=0.00..17.29 rows=1369 width=0) Index Cond: (place_id = 178) -> Parallel Bitmap Heap Scan on _hyper_5_552_chunk crh_76 (cost=19.13..73.01 rows=1 width=41) Recheck Cond: ((timestamp_client_start >= '2018-02-01 00:00:00'::timestamp without time zone) AND (timestamp_client_start < '2018-02-28 00:00:00'::timestamp without time zone) AND (place_id = 178)) Filter: (duration > 180) -> BitmapAnd (cost=19.13..19.13 rows=49 width=0) -> Bitmap Index Scan on _hyper_5_552_chunk_client_visit_timestamp_brin_idx (cost=0.00..3.33 rows=6300 width=0) Index Cond: ((timestamp_client_start >= '2018-02-01 00:00:00'::timestamp without time zone) AND (timestamp_client_start < '2018-02-28 00:00:00'::timestamp without time zone)) -> Bitmap Index Scan on _hyper_5_552_chunk_client_visit_pid_idx (cost=0.00..15.55 rows=1284 width=0) Index Cond: (place_id = 178) -> Parallel Bitmap Heap Scan on _hyper_5_553_chunk crh_77 (cost=21.22..83.83 rows=1 width=41) Recheck Cond: ((timestamp_client_start >= '2018-02-01 00:00:00'::timestamp without time zone) AND (timestamp_client_start < '2018-02-28 00:00:00'::timestamp without time zone) AND (place_id = 178)) Filter: (duration > 180) -> BitmapAnd (cost=21.22..21.22 rows=57 width=0) -> Bitmap Index Scan on _hyper_5_553_chunk_client_visit_timestamp_brin_idx (cost=0.00..3.33 rows=6293 width=0) Index Cond: ((timestamp_client_start >= '2018-02-01 00:00:00'::timestamp without time zone) AND (timestamp_client_start < '2018-02-28 00:00:00'::timestamp without time zone)) -> Bitmap Index Scan on _hyper_5_553_chunk_client_visit_pid_idx (cost=0.00..17.64 rows=1416 width=0) Index Cond: (place_id = 178) -> Parallel Bitmap Heap Scan on _hyper_5_554_chunk crh_78 (cost=20.03..81.54 rows=1 width=41) Recheck Cond: ((timestamp_client_start >= '2018-02-01 00:00:00'::timestamp without time zone) AND (timestamp_client_start < '2018-02-28 00:00:00'::timestamp without time zone) AND (place_id = 178)) Filter: (duration > 180) -> BitmapAnd (cost=20.03..20.03 rows=56 width=0) -> Bitmap Index Scan on _hyper_5_554_chunk_client_visit_timestamp_brin_idx (cost=0.00..3.33 rows=6242 width=0) Index Cond: ((timestamp_client_start >= '2018-02-01 00:00:00'::timestamp without time zone) AND (timestamp_client_start < '2018-02-28 00:00:00'::timestamp without time zone)) -> Bitmap Index Scan on _hyper_5_554_chunk_client_visit_pid_idx (cost=0.00..16.45 rows=1404 width=0) Index Cond: (place_id = 178) -> Parallel Bitmap Heap Scan on _hyper_5_555_chunk crh_79 (cost=19.87..80.29 rows=1 width=41) Recheck Cond: ((timestamp_client_start >= '2018-02-01 00:00:00'::timestamp without time zone) AND (timestamp_client_start < '2018-02-28 00:00:00'::timestamp without time zone) AND (place_id = 178)) Filter: (duration > 180) -> BitmapAnd (cost=19.87..19.87 rows=55 width=0) -> Bitmap Index Scan on _hyper_5_555_chunk_client_visit_timestamp_brin_idx (cost=0.00..3.33 rows=6344 width=0) Index Cond: ((timestamp_client_start >= '2018-02-01 00:00:00'::timestamp without time zone) AND (timestamp_client_start < '2018-02-28 00:00:00'::timestamp without time zone)) -> Bitmap Index Scan on _hyper_5_555_chunk_client_visit_pid_idx (cost=0.00..16.29 rows=1382 width=0) Index Cond: (place_id = 178) -> Parallel Bitmap Heap Scan on _hyper_5_556_chunk crh_80 (cost=18.80..80.25 rows=1 width=41) Recheck Cond: ((timestamp_client_start >= '2018-02-01 00:00:00'::timestamp without time zone) AND (timestamp_client_start < '2018-02-28 00:00:00'::timestamp without time zone) AND (place_id = 178)) Filter: (duration > 180) -> BitmapAnd (cost=18.80..18.80 rows=56 width=0) -> Bitmap Index Scan on _hyper_5_556_chunk_client_visit_timestamp_brin_idx (cost=0.00..3.33 rows=6124 width=0) Index Cond: ((timestamp_client_start >= '2018-02-01 00:00:00'::timestamp without time zone) AND (timestamp_client_start < '2018-02-28 00:00:00'::timestamp without time zone)) -> Bitmap Index Scan on _hyper_5_556_chunk_client_visit_pid_idx (cost=0.00..15.22 rows=1240 width=0) Index Cond: (place_id = 178) -> Parallel Bitmap Heap Scan on _hyper_5_557_chunk crh_81 (cost=19.33..81.90 rows=1 width=41) Recheck Cond: ((timestamp_client_start >= '2018-02-01 00:00:00'::timestamp without time zone) AND (timestamp_client_start < '2018-02-28 00:00:00'::timestamp without time zone) AND (place_id = 178)) Filter: (duration > 180) -> BitmapAnd (cost=19.33..19.33 rows=57 width=0) -> Bitmap Index Scan on _hyper_5_557_chunk_client_visit_timestamp_brin_idx (cost=0.00..3.33 rows=6320 width=0) Index Cond: ((timestamp_client_start >= '2018-02-01 00:00:00'::timestamp without time zone) AND (timestamp_client_start < '2018-02-28 00:00:00'::timestamp without time zone)) -> Bitmap Index Scan on _hyper_5_557_chunk_client_visit_pid_idx (cost=0.00..15.74 rows=1310 width=0) Index Cond: (place_id = 178) -> Parallel Bitmap Heap Scan on _hyper_5_558_chunk crh_82 (cost=19.57..83.24 rows=1 width=41) Recheck Cond: ((timestamp_client_start >= '2018-02-01 00:00:00'::timestamp without time zone) AND (timestamp_client_start < '2018-02-28 00:00:00'::timestamp without time zone) AND (place_id = 178)) Filter: (duration > 180) -> BitmapAnd (cost=19.57..19.57 rows=58 width=0) -> Bitmap Index Scan on _hyper_5_558_chunk_client_visit_timestamp_brin_idx (cost=0.00..3.33 rows=6323 width=0) Index Cond: ((timestamp_client_start >= '2018-02-01 00:00:00'::timestamp without time zone) AND (timestamp_client_start < '2018-02-28 00:00:00'::timestamp without time zone)) -> Bitmap Index Scan on _hyper_5_558_chunk_client_visit_pid_idx (cost=0.00..15.99 rows=1343 width=0) Index Cond: (place_id = 178) -> Parallel Bitmap Heap Scan on _hyper_5_559_chunk crh_83 (cost=19.09..85.98 rows=1 width=41) Recheck Cond: ((timestamp_client_start >= '2018-02-01 00:00:00'::timestamp without time zone) AND (timestamp_client_start < '2018-02-28 00:00:00'::timestamp without time zone) AND (place_id = 178)) Filter: (duration > 180) -> BitmapAnd (cost=19.09..19.09 rows=61 width=0) -> Bitmap Index Scan on _hyper_5_559_chunk_client_visit_timestamp_brin_idx (cost=0.00..3.33 rows=6359 width=0) Index Cond: ((timestamp_client_start >= '2018-02-01 00:00:00'::timestamp without time zone) AND (timestamp_client_start < '2018-02-28 00:00:00'::timestamp without time zone)) -> Bitmap Index Scan on _hyper_5_559_chunk_client_visit_pid_idx (cost=0.00..15.50 rows=1278 width=0) Index Cond: (place_id = 178) -> Parallel Bitmap Heap Scan on _hyper_5_560_chunk crh_84 (cost=18.61..85.47 rows=1 width=41) Recheck Cond: ((timestamp_client_start >= '2018-02-01 00:00:00'::timestamp without time zone) AND (timestamp_client_start < '2018-02-28 00:00:00'::timestamp without time zone) AND (place_id = 178)) Filter: (duration > 180) -> BitmapAnd (cost=18.61..18.61 rows=61 width=0) -> Bitmap Index Scan on _hyper_5_560_chunk_client_visit_timestamp_brin_idx (cost=0.00..3.33 rows=6365 width=0) Index Cond: ((timestamp_client_start >= '2018-02-01 00:00:00'::timestamp without time zone) AND (timestamp_client_start < '2018-02-28 00:00:00'::timestamp without time zone)) -> Bitmap Index Scan on _hyper_5_560_chunk_client_visit_pid_idx (cost=0.00..15.02 rows=1214 width=0) Index Cond: (place_id = 178) -> Parallel Bitmap Heap Scan on _hyper_5_561_chunk crh_85 (cost=11.79..63.23 rows=1 width=41) Recheck Cond: ((timestamp_client_start >= '2018-02-01 00:00:00'::timestamp without time zone) AND (timestamp_client_start < '2018-02-28 00:00:00'::timestamp without time zone) AND (place_id = 178)) Filter: (duration > 180) -> BitmapAnd (cost=11.79..11.79 rows=47 width=0) -> Bitmap Index Scan on _hyper_5_561_chunk_client_visit_timestamp_brin_idx (cost=0.00..3.33 rows=6089 width=0) Index Cond: ((timestamp_client_start >= '2018-02-01 00:00:00'::timestamp without time zone) AND (timestamp_client_start < '2018-02-28 00:00:00'::timestamp without time zone)) -> Bitmap Index Scan on _hyper_5_561_chunk_client_visit_pid_idx (cost=0.00..8.21 rows=615 width=0) Index Cond: (place_id = 178) -> Parallel Bitmap Heap Scan on _hyper_5_562_chunk crh_86 (cost=12.54..72.67 rows=1 width=41) Recheck Cond: ((timestamp_client_start >= '2018-02-01 00:00:00'::timestamp without time zone) AND (timestamp_client_start < '2018-02-28 00:00:00'::timestamp without time zone) AND (place_id = 178)) Filter: (duration > 180) -> BitmapAnd (cost=12.54..12.54 rows=55 width=0) -> Bitmap Index Scan on _hyper_5_562_chunk_client_visit_timestamp_brin_idx (cost=0.00..3.33 rows=6195 width=0) Index Cond: ((timestamp_client_start >= '2018-02-01 00:00:00'::timestamp without time zone) AND (timestamp_client_start < '2018-02-28 00:00:00'::timestamp without time zone)) -> Bitmap Index Scan on _hyper_5_562_chunk_client_visit_pid_idx (cost=0.00..8.96 rows=715 width=0) Index Cond: (place_id = 178) -> Parallel Bitmap Heap Scan on _hyper_5_563_chunk crh_87 (cost=12.37..70.34 rows=1 width=41) Recheck Cond: ((timestamp_client_start >= '2018-02-01 00:00:00'::timestamp without time zone) AND (timestamp_client_start < '2018-02-28 00:00:00'::timestamp without time zone) AND (place_id = 178)) Filter: (duration > 180) -> BitmapAnd (cost=12.37..12.37 rows=53 width=0) -> Bitmap Index Scan on _hyper_5_563_chunk_client_visit_timestamp_brin_idx (cost=0.00..3.33 rows=6331 width=0) Index Cond: ((timestamp_client_start >= '2018-02-01 00:00:00'::timestamp without time zone) AND (timestamp_client_start < '2018-02-28 00:00:00'::timestamp without time zone)) -> Bitmap Index Scan on _hyper_5_563_chunk_client_visit_pid_idx (cost=0.00..8.79 rows=693 width=0) Index Cond: (place_id = 178) -> Parallel Bitmap Heap Scan on _hyper_5_564_chunk crh_88 (cost=12.04..75.34 rows=1 width=41) Recheck Cond: ((timestamp_client_start >= '2018-02-01 00:00:00'::timestamp without time zone) AND (timestamp_client_start < '2018-02-28 00:00:00'::timestamp without time zone) AND (place_id = 178)) Filter: (duration > 180) -> BitmapAnd (cost=12.04..12.04 rows=59 width=0) -> Bitmap Index Scan on _hyper_5_564_chunk_client_visit_timestamp_brin_idx (cost=0.00..3.33 rows=6268 width=0) Index Cond: ((timestamp_client_start >= '2018-02-01 00:00:00'::timestamp without time zone) AND (timestamp_client_start < '2018-02-28 00:00:00'::timestamp without time zone)) -> Bitmap Index Scan on _hyper_5_564_chunk_client_visit_pid_idx (cost=0.00..8.46 rows=649 width=0) Index Cond: (place_id = 178) -> Parallel Bitmap Heap Scan on _hyper_5_565_chunk crh_89 (cost=13.17..78.73 rows=1 width=41) Recheck Cond: ((timestamp_client_start >= '2018-02-01 00:00:00'::timestamp without time zone) AND (timestamp_client_start < '2018-02-28 00:00:00'::timestamp without time zone) AND (place_id = 178)) Filter: (duration > 180) -> BitmapAnd (cost=13.17..13.17 rows=61 width=0) -> Bitmap Index Scan on _hyper_5_565_chunk_client_visit_timestamp_brin_idx (cost=0.00..3.33 rows=6207 width=0) Index Cond: ((timestamp_client_start >= '2018-02-01 00:00:00'::timestamp without time zone) AND (timestamp_client_start < '2018-02-28 00:00:00'::timestamp without time zone)) -> Bitmap Index Scan on _hyper_5_565_chunk_client_visit_pid_idx (cost=0.00..9.59 rows=799 width=0) Index Cond: (place_id = 178) -> Parallel Bitmap Heap Scan on _hyper_5_566_chunk crh_90 (cost=12.93..73.08 rows=1 width=41) Recheck Cond: ((timestamp_client_start >= '2018-02-01 00:00:00'::timestamp without time zone) AND (timestamp_client_start < '2018-02-28 00:00:00'::timestamp without time zone) AND (place_id = 178)) Filter: (duration > 180) -> BitmapAnd (cost=12.93..12.93 rows=55 width=0) -> Bitmap Index Scan on _hyper_5_566_chunk_client_visit_timestamp_brin_idx (cost=0.00..3.33 rows=6042 width=0) Index Cond: ((timestamp_client_start >= '2018-02-01 00:00:00'::timestamp without time zone) AND (timestamp_client_start < '2018-02-28 00:00:00'::timestamp without time zone)) -> Bitmap Index Scan on _hyper_5_566_chunk_client_visit_pid_idx (cost=0.00..9.35 rows=767 width=0) Index Cond: (place_id = 178) -> Parallel Bitmap Heap Scan on _hyper_5_567_chunk crh_91 (cost=13.92..94.65 rows=1 width=41) Recheck Cond: ((timestamp_client_start >= '2018-02-01 00:00:00'::timestamp without time zone) AND (timestamp_client_start < '2018-02-28 00:00:00'::timestamp without time zone) AND (place_id = 178)) Filter: (duration > 180) -> BitmapAnd (cost=13.92..13.92 rows=75 width=0) -> Bitmap Index Scan on _hyper_5_567_chunk_client_visit_timestamp_brin_idx (cost=0.00..3.34 rows=7646 width=0) Index Cond: ((timestamp_client_start >= '2018-02-01 00:00:00'::timestamp without time zone) AND (timestamp_client_start < '2018-02-28 00:00:00'::timestamp without time zone)) -> Bitmap Index Scan on _hyper_5_567_chunk_client_visit_pid_idx (cost=0.00..10.32 rows=751 width=0) Index Cond: (place_id = 178) -> Parallel Bitmap Heap Scan on _hyper_5_572_chunk crh_92 (cost=12.79..808.70 rows=1 width=41) Recheck Cond: (place_id = 178) Filter: ((duration > 180) AND (timestamp_client_start >= '2018-02-01 00:00:00'::timestamp without time zone) AND (timestamp_client_start < '2018-02-28 00:00:00'::timestamp without time zone)) -> Bitmap Index Scan on _hyper_5_572_chunk_client_visit_pid_idx (cost=0.00..12.79 rows=933 width=0) Index Cond: (place_id = 178) -> Parallel Bitmap Heap Scan on _hyper_5_573_chunk crh_93 (cost=10.75..712.28 rows=1 width=41) Recheck Cond: (place_id = 178) Filter: ((duration > 180) AND (timestamp_client_start >= '2018-02-01 00:00:00'::timestamp without time zone) AND (timestamp_client_start < '2018-02-28 00:00:00'::timestamp without time zone)) -> Bitmap Index Scan on _hyper_5_573_chunk_client_visit_pid_idx (cost=0.00..10.75 rows=807 width=0) Index Cond: (place_id = 178) -> Parallel Bitmap Heap Scan on _hyper_5_574_chunk crh_94 (cost=11.43..770.84 rows=1 width=41) Recheck Cond: (place_id = 178) Filter: ((duration > 180) AND (timestamp_client_start >= '2018-02-01 00:00:00'::timestamp without time zone) AND (timestamp_client_start < '2018-02-28 00:00:00'::timestamp without time zone)) -> Bitmap Index Scan on _hyper_5_574_chunk_client_visit_pid_idx (cost=0.00..11.43 rows=898 width=0) Index Cond: (place_id = 178) -> Parallel Bitmap Heap Scan on _hyper_5_575_chunk crh_95 (cost=14.01..927.07 rows=1 width=41) Recheck Cond: (place_id = 178) Filter: ((duration > 180) AND (timestamp_client_start >= '2018-02-01 00:00:00'::timestamp without time zone) AND (timestamp_client_start < '2018-02-28 00:00:00'::timestamp without time zone)) -> Bitmap Index Scan on _hyper_5_575_chunk_client_visit_pid_idx (cost=0.00..14.01 rows=1079 width=0) Index Cond: (place_id = 178) -> Parallel Bitmap Heap Scan on _hyper_5_582_chunk crh_96 (cost=14.68..878.20 rows=1 width=41) Recheck Cond: (place_id = 178) Filter: ((duration > 180) AND (timestamp_client_start >= '2018-02-01 00:00:00'::timestamp without time zone) AND (timestamp_client_start < '2018-02-28 00:00:00'::timestamp without time zone)) -> Bitmap Index Scan on _hyper_5_582_chunk_client_visit_pid_idx (cost=0.00..14.68 rows=1022 width=0) Index Cond: (place_id = 178) -> Parallel Bitmap Heap Scan on _hyper_5_597_chunk crh_97 (cost=18.26..128.92 rows=1 width=41) Recheck Cond: ((timestamp_client_start >= '2018-02-01 00:00:00'::timestamp without time zone) AND (timestamp_client_start < '2018-02-28 00:00:00'::timestamp without time zone) AND (place_id = 178)) Filter: (duration > 180) -> BitmapAnd (cost=18.26..18.26 rows=102 width=0) -> Bitmap Index Scan on _hyper_5_597_chunk_client_visit_timestamp_brin_idx (cost=0.00..3.42 rows=11006 width=0) Index Cond: ((timestamp_client_start >= '2018-02-01 00:00:00'::timestamp without time zone) AND (timestamp_client_start < '2018-02-28 00:00:00'::timestamp without time zone)) -> Bitmap Index Scan on _hyper_5_597_chunk_client_visit_pid_idx (cost=0.00..14.59 rows=863 width=0) Index Cond: (place_id = 178) -> Parallel Bitmap Heap Scan on _hyper_5_609_chunk crh_98 (cost=14.56..847.83 rows=1 width=41) Recheck Cond: (place_id = 178) Filter: ((duration > 180) AND (timestamp_client_start >= '2018-02-01 00:00:00'::timestamp without time zone) AND (timestamp_client_start < '2018-02-28 00:00:00'::timestamp without time zone)) -> Bitmap Index Scan on _hyper_5_609_chunk_client_visit_pid_idx (cost=0.00..14.56 rows=859 width=0) Index Cond: (place_id = 178) -> Parallel Bitmap Heap Scan on _hyper_5_616_chunk crh_99 (cost=16.47..957.20 rows=1 width=41) Recheck Cond: (place_id = 178) Filter: ((duration > 180) AND (timestamp_client_start >= '2018-02-01 00:00:00'::timestamp without time zone) AND (timestamp_client_start < '2018-02-28 00:00:00'::timestamp without time zone)) -> Bitmap Index Scan on _hyper_5_616_chunk_client_visit_pid_idx (cost=0.00..16.47 rows=967 width=0) Index Cond: (place_id = 178) -> Parallel Bitmap Heap Scan on _hyper_5_623_chunk crh_100 (cost=22.01..108.86 rows=1 width=41) Recheck Cond: ((timestamp_client_start >= '2018-02-01 00:00:00'::timestamp without time zone) AND (timestamp_client_start < '2018-02-28 00:00:00'::timestamp without time zone) AND (place_id = 178)) Filter: (duration > 180) -> BitmapAnd (cost=22.01..22.01 rows=79 width=0) -> Bitmap Index Scan on _hyper_5_623_chunk_client_visit_timestamp_brin_idx (cost=0.00..3.38 rows=9879 width=0) Index Cond: ((timestamp_client_start >= '2018-02-01 00:00:00'::timestamp without time zone) AND (timestamp_client_start < '2018-02-28 00:00:00'::timestamp without time zone)) -> Bitmap Index Scan on _hyper_5_623_chunk_client_visit_pid_idx (cost=0.00..18.38 rows=1221 width=0) Index Cond: (place_id = 178) -> Parallel Bitmap Heap Scan on _hyper_5_632_chunk crh_101 (cost=16.53..67.10 rows=1 width=41) Recheck Cond: ((timestamp_client_start >= '2018-02-01 00:00:00'::timestamp without time zone) AND (timestamp_client_start < '2018-02-28 00:00:00'::timestamp without time zone) AND (place_id = 178)) Filter: (duration > 180) -> BitmapAnd (cost=16.53..16.53 rows=46 width=0) -> Bitmap Index Scan on _hyper_5_632_chunk_client_visit_timestamp_brin_idx (cost=0.00..3.33 rows=6521 width=0) Index Cond: ((timestamp_client_start >= '2018-02-01 00:00:00'::timestamp without time zone) AND (timestamp_client_start < '2018-02-28 00:00:00'::timestamp without time zone)) -> Bitmap Index Scan on _hyper_5_632_chunk_client_visit_pid_idx (cost=0.00..12.94 rows=1083 width=0) Index Cond: (place_id = 178) -> Parallel Bitmap Heap Scan on _hyper_5_637_chunk crh_102 (cost=17.90..64.14 rows=1 width=41) Recheck Cond: ((timestamp_client_start >= '2018-02-01 00:00:00'::timestamp without time zone) AND (timestamp_client_start < '2018-02-28 00:00:00'::timestamp without time zone) AND (place_id = 178)) Filter: (duration > 180) -> BitmapAnd (cost=17.90..17.90 rows=42 width=0) -> Bitmap Index Scan on _hyper_5_637_chunk_client_visit_timestamp_brin_idx (cost=0.00..3.33 rows=5725 width=0) Index Cond: ((timestamp_client_start >= '2018-02-01 00:00:00'::timestamp without time zone) AND (timestamp_client_start < '2018-02-28 00:00:00'::timestamp without time zone)) -> Bitmap Index Scan on _hyper_5_637_chunk_client_visit_pid_idx (cost=0.00..14.32 rows=1120 width=0) Index Cond: (place_id = 178) -> Parallel Bitmap Heap Scan on _hyper_5_643_chunk crh_103 (cost=18.11..69.78 rows=1 width=41) Recheck Cond: ((timestamp_client_start >= '2018-02-01 00:00:00'::timestamp without time zone) AND (timestamp_client_start < '2018-02-28 00:00:00'::timestamp without time zone) AND (place_id = 178)) Filter: (duration > 180) -> BitmapAnd (cost=18.11..18.11 rows=47 width=0) -> Bitmap Index Scan on _hyper_5_643_chunk_client_visit_timestamp_brin_idx (cost=0.00..3.33 rows=6518 width=0) Index Cond: ((timestamp_client_start >= '2018-02-01 00:00:00'::timestamp without time zone) AND (timestamp_client_start < '2018-02-28 00:00:00'::timestamp without time zone)) -> Bitmap Index Scan on _hyper_5_643_chunk_client_visit_pid_idx (cost=0.00..14.52 rows=1147 width=0) Index Cond: (place_id = 178) -> Parallel Bitmap Heap Scan on _hyper_5_653_chunk crh_104 (cost=18.08..67.58 rows=1 width=41) Recheck Cond: ((timestamp_client_start >= '2018-02-01 00:00:00'::timestamp without time zone) AND (timestamp_client_start < '2018-02-28 00:00:00'::timestamp without time zone) AND (place_id = 178)) Filter: (duration > 180) -> BitmapAnd (cost=18.08..18.08 rows=45 width=0) -> Bitmap Index Scan on _hyper_5_653_chunk_client_visit_timestamp_brin_idx (cost=0.00..3.33 rows=6597 width=0) Index Cond: ((timestamp_client_start >= '2018-02-01 00:00:00'::timestamp without time zone) AND (timestamp_client_start < '2018-02-28 00:00:00'::timestamp without time zone)) -> Bitmap Index Scan on _hyper_5_653_chunk_client_visit_pid_idx (cost=0.00..14.49 rows=1143 width=0) Index Cond: (place_id = 178) -> Parallel Bitmap Heap Scan on _hyper_5_657_chunk crh_105 (cost=18.16..64.39 rows=1 width=41) Recheck Cond: ((timestamp_client_start >= '2018-02-01 00:00:00'::timestamp without time zone) AND (timestamp_client_start < '2018-02-28 00:00:00'::timestamp without time zone) AND (place_id = 178)) Filter: (duration > 180) -> BitmapAnd (cost=18.16..18.16 rows=42 width=0) -> Bitmap Index Scan on _hyper_5_657_chunk_client_visit_timestamp_brin_idx (cost=0.00..3.33 rows=6432 width=0) Index Cond: ((timestamp_client_start >= '2018-02-01 00:00:00'::timestamp without time zone) AND (timestamp_client_start < '2018-02-28 00:00:00'::timestamp without time zone)) -> Bitmap Index Scan on _hyper_5_657_chunk_client_visit_pid_idx (cost=0.00..14.57 rows=1154 width=0) Index Cond: (place_id = 178) -> Parallel Bitmap Heap Scan on _hyper_5_664_chunk crh_106 (cost=16.66..54.15 rows=1 width=41) Recheck Cond: ((timestamp_client_start >= '2018-02-01 00:00:00'::timestamp without time zone) AND (timestamp_client_start < '2018-02-28 00:00:00'::timestamp without time zone) AND (place_id = 178)) Filter: (duration > 180) -> BitmapAnd (cost=16.66..16.66 rows=34 width=0) -> Bitmap Index Scan on _hyper_5_664_chunk_client_visit_timestamp_brin_idx (cost=0.00..3.33 rows=6481 width=0) Index Cond: ((timestamp_client_start >= '2018-02-01 00:00:00'::timestamp without time zone) AND (timestamp_client_start < '2018-02-28 00:00:00'::timestamp without time zone)) -> Bitmap Index Scan on _hyper_5_664_chunk_client_visit_pid_idx (cost=0.00..13.08 rows=1101 width=0) Index Cond: (place_id = 178) -> Parallel Bitmap Heap Scan on _hyper_5_672_chunk crh_107 (cost=18.75..59.54 rows=1 width=41) Recheck Cond: ((timestamp_client_start >= '2018-02-01 00:00:00'::timestamp without time zone) AND (timestamp_client_start < '2018-02-28 00:00:00'::timestamp without time zone) AND (place_id = 178)) Filter: (duration > 180) -> BitmapAnd (cost=18.75..18.75 rows=37 width=0) -> Bitmap Index Scan on _hyper_5_672_chunk_client_visit_timestamp_brin_idx (cost=0.00..3.33 rows=6503 width=0) Index Cond: ((timestamp_client_start >= '2018-02-01 00:00:00'::timestamp without time zone) AND (timestamp_client_start < '2018-02-28 00:00:00'::timestamp without time zone)) -> Bitmap Index Scan on _hyper_5_672_chunk_client_visit_pid_idx (cost=0.00..15.17 rows=1233 width=0) Index Cond: (place_id = 178) -> Parallel Index Scan using _hyper_5_680_chunk_client_visit_pid_idx on _hyper_5_680_chunk crh_108 (cost=0.14..2.36 rows=1 width=94) Index Cond: (place_id = 178) Filter: ((duration > 180) AND (timestamp_client_start >= '2018-02-01 00:00:00'::timestamp without time zone) AND (timestamp_client_start < '2018-02-28 00:00:00'::timestamp without time zone)) -> Index Scan using client_loc_pkey on client_location_history cl (cost=0.42..2.31 rows=1 width=47) Index Cond: (cid = (crh.cid)::bpchar) -> Materialize (cost=100.00..127.24 rows=7 width=36) -> Foreign Scan on place p (cost=100.00..127.20 rows=7 width=36) -> GroupAggregate (cost=7045.02..7045.05 rows=1 width=88) Group Key: t1.nb, (max(t1_1.nb)) -> Sort (cost=7045.02..7045.02 rows=1 width=48) Sort Key: t1.nb, (max(t1_1.nb)) -> Nested Loop Left Join (cost=446.51..7045.01 rows=1 width=48) -> CTE Scan on t1 (cost=0.00..6598.46 rows=1 width=40) Filter: ((geom && st_expand(st_transform((location)::geometry, st_srid(geom)), '50000'::double precision)) AND (st_transform((location)::geometry, st_srid(geom)) && st_expand(geom, '50000'::double precision)) AND _st_dwithin(geom, st_transform((location)::geometry, st_srid(geom)), '50000'::double precision)) -> Aggregate (cost=446.51..446.52 rows=1 width=8) -> CTE Scan on t1 t1_1 (cost=0.00..396.90 rows=19845 width=8) -> CTE Scan on t3 (cost=0.00..0.02 rows=1 width=52)